|
| creator |
Schwarz, Holger
| | Wagner, Ralf
| | Mitschang, Bernhard
| | date |
2001-05
| | | | description |
20 pages
| |
Many decision support applications are built upon data mining and
OLAP tools and allow us-ers to answer information requests based on
a data warehouse that is managed by a powerful DBMS. In this paper,
we focus on tools that generate sequences of SQL statements in order
to produce the requested information. Our thorough analysis revealed
that many sequences of que-ries that are generated by commercial
tools are not very efficient. An optimized system architec-ture is
suggested for these applications. The main component is a DSS
optimizer that accepts pre-viously generated sequences of queries
and remodels them according to a set of optimization strategies,
before they are executed by the underlying database system. The
advantages of this extended architecture are discussed and a couple
of appropriate optimization strategies are iden-tified. Experimental
results are given, showing that these strategies are appropriate to
optimize query sequences of OLAP applications.
| | format |
application/postscript
| | 1090725 Bytes | |